A schema contains named objects (tables, views, functions, etc) whose names may duplicate those of other objects existing in other schemas.
The schema name must be distinct from any existing schema name in the current database.
Create Schema
Note: Support from SQL Server 2005 or later and SQL Azure.
To create a new schema
- Control-click the database in the navigation pane and choose New Schema.
- Edit schema properties on the appropriate tabs of the Schema Designer.
Edit Schema
Note: Support from SQL Server 2005 or later and SQL Azure.
To edit the existing schema (manage its general etc)
- Control-click the schema in the navigation pane and choose Schema Properties....
- Edit schema properties on the appropriate tabs of the Schema Designer.
Open Schema
To open a schema which shows in the navigation pane
- Double-click the schema to open in the navigation pane.
or - Control-click the schema and choose Open Schema.
Close Schema
To close a schema
- Control-click the schema in the navigation pane and choose Close Schema.
Delete Schema
Note: Support from SQL Server 2005 or later and SQL Azure.
To delete a schema
- Control-click the schema in the navigation pane and choose Delete Schema.
- Confirm removing in the dialog window.